package com.ceba.test.modules.statistic.dao.sqlconstants;

public class StatisticSqlConstants {

  public static	String condition = "select * from (";

	
  public static String sqlCondition_report_sign =
          "select cb_report_sign.*,cb_report_sign.FILE_NAME AS GFILE_NAME FROM cb_report_sign ";
//		  "select cb_report_sign.*,g_file.FILE_NAME AS GFILE_NAME FROM cb_report_sign LEFT JOIN g_file ON cb_report_sign.FILE_ID = g_file.ID ";
//			"select cb_report_sign.ID,cb_report_sign.REPORT_ID,'--' as NO, '--' as COMPANY_NAME,"
//					+ " cb_report_sign.SIGN_FILE_ID AS FILE_ID,g_file.FILE_NAME,cb_report_sign.CREATE_TIME,0 AS FILE_TYPE   "
//					+ " from cb_report_sign LEFT OUTER JOIN g_file  on g_file.ID = cb_report_sign.SIGN_FILE_ID";
 
	
	
}
